'use strict'

const pg = require('pg')

let psql = new pg.Pool({
  host: '127.0.0.1',
  port: 5432,
  user: 'azx',
  password: '123456789',
  database: 'azx',
  //最大客户端连接数量。
  max: 8
})

;(async () => {
  let sqltext = `insert into `
          + `content(id, title, detail, add_time, update_time)`
          + ` values ($1, $2, $3, $4, $5)`

  let tm = Date.now()

  let ret = await psql.query(sqltext, [
      `${tm}`,
      `${Math.random()}`,
      '测试内容',
      tm,
      tm
  ])

  let ret2 = await psql.query(`select * from content`)

  psql.end()

  console.log(ret, ret2)

})();
